package cn.zhf.shop.mapper;

import cn.zhf.shop.entity.CreditApply;
import cn.zhf.shop.entity.search.CreditApplySearch;
import org.apache.ibatis.annotations.Mapper;import org.apache.ibatis.annotations.Param;import java.util.List;

@Mapper
public interface CreditApplyMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(CreditApply record);

    int insertSelective(CreditApply record);

    CreditApply selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(CreditApply record);

    int updateByPrimaryKey(CreditApply record);

    List<CreditApply> selectAll();

    List<CreditApply> selectByUserName(@Param("userName") String userName);

    int updateResultById(@Param("updatedResult") Integer updatedResult, @Param("id") Integer id);

    List<CreditApply> selectByPhone(@Param("phone") String phone);

    //条件搜索
    List<CreditApply> selectByIdAndBankNameAndUserNameAndPhoneAndResultAndUserIdcard2(@Param("id")Integer id,@Param("bankName")String bankName,@Param("userName")String userName,@Param("phone")String phone,@Param("result")Integer result,@Param("userIdcard")String userIdcard);

    //模糊搜索
    List<CreditApply> selectByIdAndBankNameAndUserNameAndPhoneAndUserIdcard(String str);

    List<CreditApply> selectAllByResult(@Param("result")Integer result);

    List<CreditApply> selectByUserIdcard(@Param("userIdcard")String userIdcard);

    List<CreditApply> selectByUserIdcardAndResultAndPhoneAndBankNameAndUserName(CreditApplySearch creditApplySearch);

    List<CreditApply> selectByBankNameAndUserIdcard(@Param("bankName")String bankName,@Param("userIdcard")String userIdcard);





}